1. Open the Side Menu and select the list you would like to edit.
2. Click the properties icon on the top toolbar.
3. In the resulting List Properties, edit the Name, Icon or SQL.
For more information and examples on List SQL, click here.
4. Select the Save button to confirm your changes.
The SQL field will accept any standard SQL queries, including sorting and joins. Use the following notation to select database elements:
[_TableName].[FieldName]
For example, the following query will display employees who have been assigned to desks.
SELECT [_Employees].[LastName], [_Employees].[FirstName], [_Desks].[deskname], [_Floors].[FloorName] FROM [_Employees] INNER JOIN [_Desks] ON [_Employees].[Desk_id]=[_Desks].[desk_id]INNER JOIN [_Floors] ON [_Employees].[Floor_Id]=[_Floors].[floor_id]
You can learn more about SQL queries at w3schools.com.
This website was made with Mobirise site theme